Profile Report

Dataset statistics

Number of variables	16
Number of observations	1209
Missing cells	855
Missing cells (%)	4.4%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	151.2 KiB
Average record size in memory	128.1 B

Variable types

DateTime	1
Numeric	15

Alerts

`Consumption` is highly correlated with `Combined Cycle Generation` and 2 other fields	High correlation
`Wind Generation` is highly correlated with `Combined Cycle Generation` and 1 other fields	High correlation
`Combined Cycle Generation` is highly correlated with `Consumption` and 3 other fields	High correlation
`Total emissions (tCO2eq)` is highly correlated with `Consumption` and 3 other fields	High correlation
`tCO2/MWh` is highly correlated with `Wind Generation` and 3 other fields	High correlation
`Electricity Price` is highly correlated with `Solar Generation` and 5 other fields	High correlation
`Electricity Price 24h` is highly correlated with `Solar Generation` and 5 other fields	High correlation
`Electricity Price 7d` is highly correlated with `Solar Generation` and 5 other fields	High correlation
`Gas Price` is highly correlated with `Consumption` and 8 other fields	High correlation
`Gas Price 24h` is highly correlated with `Solar Generation` and 5 other fields	High correlation
`Gas Price 7d` is highly correlated with `Solar Generation` and 5 other fields	High correlation
`Solar Generation` is highly correlated with `Electricity Price` and 4 other fields	High correlation
`Hydropower Generation` is highly correlated with `Gas Price`	High correlation
`Gas Price` has 851 (70.4%) missing values	Missing
`datetime` has unique values	Unique
`Consumption` has unique values	Unique
`Wind Generation` has unique values	Unique
`Hydropower Generation` has unique values	Unique
`Combined Cycle Generation` has unique values	Unique
`Total emissions (tCO2eq)` has unique values	Unique

Reproduction

Analysis started	2022-12-19 11:41:49.375553
Analysis finished	2022-12-19 11:42:04.604086
Duration	15.23 seconds
Software version	pandas-profiling v3.3.0
Download configuration	config.json

datetime
Date

UNIQUE

Distinct	1209
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	9.6 KiB

Minimum	2019-01-08 00:00:00
Maximum	2022-04-30 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Consumption
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	1209
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	666266.5045

Minimum	474176
Maximum	846631.4
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.6 KiB

Quantile statistics

Minimum	474176
5-th percentile	545202.48
Q1	618178.6
median	673593
Q3	713659.3
95-th percentile	771092.9
Maximum	846631.4
Range	372455.4
Interquartile range (IQR)	95480.7

Descriptive statistics

Standard deviation	69030.9016
Coefficient of variation (CV)	0.1036085427
Kurtosis	-0.2628945034
Mean	666266.5045
Median Absolute Deviation (MAD)	45223.3
Skewness	-0.2474858152
Sum	805516203.9
Variance	4765265376
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
805391.7	1	0.1%
664061.6	1	0.1%
543850.3	1	0.1%
618570.7	1	0.1%
684346.6	1	0.1%
690482.2	1	0.1%
701831.1	1	0.1%
708593.8	1	0.1%
701923.4	1	0.1%
600075.3	1	0.1%
Other values (1199)	1199	99.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
474176	1	0.1%
482228.5	1	0.1%
482767.1	1	0.1%
486024.5	1	0.1%
487247.5	1	0.1%
489214	1	0.1%
489532	1	0.1%
491226.8	1	0.1%
493723.7	1	0.1%
493821.6	1	0.1%

Value	Count	Frequency (%)
846631.4	1	0.1%
845359.5	1	0.1%
837014.4	1	0.1%
835205.7	1	0.1%
828296.8	1	0.1%
826671	1	0.1%
826580.2	1	0.1%
824726.7	1	0.1%
821234.9	1	0.1%
817856.6	1	0.1%

Solar Generation
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1204
Distinct (%)	99.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	42491.70033

Minimum	5663.4
Maximum	108105.9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.6 KiB

Quantile statistics

Minimum	5663.4
5-th percentile	14431.48
Q1	26827.8
median	36803.2
Q3	57777.3
95-th percentile	82366.32
Maximum	108105.9
Range	102442.5
Interquartile range (IQR)	30949.5

Descriptive statistics

Standard deviation	20727.13702
Coefficient of variation (CV)	0.4877926009
Kurtosis	-0.4538602291
Mean	42491.70033
Median Absolute Deviation (MAD)	14726
Skewness	0.5872737718
Sum	51372465.7
Variance	429614209.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
50507.6	2	0.2%
21719.8	2	0.2%
53160.2	2	0.2%
32382.2	2	0.2%
49986.9	2	0.2%
16757.9	1	0.1%
61849.7	1	0.1%
61986	1	0.1%
58769.9	1	0.1%
68722.3	1	0.1%
Other values (1194)	1194	98.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5663.4	1	0.1%
5998.6	1	0.1%
7959.7	1	0.1%
8105	1	0.1%
8151.6	1	0.1%
8155.1	1	0.1%
8691.3	1	0.1%
8824.1	1	0.1%
9267.4	1	0.1%
9787.5	1	0.1%

Value	Count	Frequency (%)
108105.9	1	0.1%
106380.2	1	0.1%
105498	1	0.1%
100920.4	1	0.1%
100820.6	1	0.1%
100676	1	0.1%
100440.9	1	0.1%
99727.5	1	0.1%
99725.9	1	0.1%
97668.4	1	0.1%

Wind Generation
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	1209
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	155669.7677

Minimum	25824.1
Maximum	430110.2
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.6 KiB

Quantile statistics

Minimum	25824.1
5-th percentile	53438.32
Q1	91220.5
median	136342
Q3	206236.6
95-th percentile	320658.26
Maximum	430110.2
Range	404286.1
Interquartile range (IQR)	115016.1

Descriptive statistics

Standard deviation	83004.27133
Coefficient of variation (CV)	0.5332073949
Kurtosis	0.1601816149
Mean	155669.7677
Median Absolute Deviation (MAD)	52201.7
Skewness	0.8612450084
Sum	188204749.2
Variance	6889709059
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
171527.7	1	0.1%
205068.6	1	0.1%
125528.4	1	0.1%
148460	1	0.1%
104912.9	1	0.1%
50030.9	1	0.1%
32119.7	1	0.1%
65947.5	1	0.1%
229113.5	1	0.1%
289298.6	1	0.1%
Other values (1199)	1199	99.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
25824.1	1	0.1%
26449.7	1	0.1%
27417	1	0.1%
29366.4	1	0.1%
29444.3	1	0.1%
32000.7	1	0.1%
32119.7	1	0.1%
34288	1	0.1%
35702.7	1	0.1%
36331.3	1	0.1%

Value	Count	Frequency (%)
430110.2	1	0.1%
417646.9	1	0.1%
409576.3	1	0.1%
408183	1	0.1%
406145.4	1	0.1%
405210.9	1	0.1%
403822	1	0.1%
398397.8	1	0.1%
392107.4	1	0.1%
388627.2	1	0.1%

Hydropower Generation
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	1209
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	60316.2225

Minimum	12400.8
Maximum	163246.4
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.6 KiB

Quantile statistics

Minimum	12400.8
5-th percentile	24930.14
Q1	38598.6
median	52868.7
Q3	75587.7
95-th percentile	127081.06
Maximum	163246.4
Range	150845.6
Interquartile range (IQR)	36989.1

Descriptive statistics

Standard deviation	30121.95488
Coefficient of variation (CV)	0.4994005531
Kurtosis	0.8917708587
Mean	60316.2225
Median Absolute Deviation (MAD)	16782.4
Skewness	1.13751033
Sum	72922313
Variance	907332165.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
55914.4	1	0.1%
86840.7	1	0.1%
55104.7	1	0.1%
74043.3	1	0.1%
111919	1	0.1%
126308.2	1	0.1%
127711.8	1	0.1%
113349	1	0.1%
93343.4	1	0.1%
43370.5	1	0.1%
Other values (1199)	1199	99.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12400.8	1	0.1%
13277.8	1	0.1%
14106.7	1	0.1%
15333.9	1	0.1%
16484.2	1	0.1%
16643.2	1	0.1%
16648.6	1	0.1%
16756.7	1	0.1%
16907.2	1	0.1%
17129.3	1	0.1%

Value	Count	Frequency (%)
163246.4	1	0.1%
159710.5	1	0.1%
159612.1	1	0.1%
154032.1	1	0.1%
153396.1	1	0.1%
152827	1	0.1%
152813.5	1	0.1%
152228.4	1	0.1%
151723.2	1	0.1%
151723.1	1	0.1%

Pump Hydro Generation
Real number (ℝ_≥0)

Distinct	1194
Distinct (%)	99.1%
Missing	4
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	6152.003402

Minimum	9.7
Maximum	28965.2
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.6 KiB

Quantile statistics

Minimum	9.7
5-th percentile	601.24
Q1	2294.7
median	4940.2
Q3	8848.1
95-th percentile	15890.52
Maximum	28965.2
Range	28955.5
Interquartile range (IQR)	6553.4

Descriptive statistics

Standard deviation	4920.980421
Coefficient of variation (CV)	0.7998988458
Kurtosis	1.494432405
Mean	6152.003402
Median Absolute Deviation (MAD)	3075.8
Skewness	1.200912232
Sum	7413164.1
Variance	24216048.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2772.2	2	0.2%
2522.5	2	0.2%
5373.2	2	0.2%
7542.4	2	0.2%
2109.1	2	0.2%
7318.3	2	0.2%
881.8	2	0.2%
11569.1	2	0.2%
22231	2	0.2%
24957.6	2	0.2%
Other values (1184)	1185	98.0%
(Missing)	4	0.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
9.7	1	0.1%
35.2	1	0.1%
41	1	0.1%
70.9	1	0.1%
72.6	1	0.1%
73	1	0.1%
80.1	1	0.1%
88	1	0.1%
89	1	0.1%
96.7	1	0.1%

Value	Count	Frequency (%)
28965.2	1	0.1%
26297.1	1	0.1%
25624.4	1	0.1%
24957.6	2	0.2%
23961.6	1	0.1%
23954.4	1	0.1%
22948.7	1	0.1%
22479.4	1	0.1%
22469.6	1	0.1%
22274.8	1	0.1%

Combined Cycle Generation
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	1209
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	118163.0775

Minimum	16887.7
Maximum	370914.9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.6 KiB

Quantile statistics

Minimum	16887.7
5-th percentile	32118.68
Q1	64153.8
median	105450.6
Q3	162177.8
95-th percentile	243796.16
Maximum	370914.9
Range	354027.2
Interquartile range (IQR)	98024

Descriptive statistics

Standard deviation	67244.51604
Coefficient of variation (CV)	0.569082301
Kurtosis	-0.1457917245
Mean	118163.0775
Median Absolute Deviation (MAD)	47942.4
Skewness	0.7004438164
Sum	142859160.7
Variance	4521824937
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
120908.1	1	0.1%
46997.3	1	0.1%
41717.1	1	0.1%
45682.5	1	0.1%
74449.5	1	0.1%
90970.2	1	0.1%
92751.2	1	0.1%
99634.7	1	0.1%
53433.5	1	0.1%
27016.1	1	0.1%
Other values (1199)	1199	99.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
16887.7	1	0.1%
17502.3	1	0.1%
17578.8	1	0.1%
17620.5	1	0.1%
18928.8	1	0.1%
19164.1	1	0.1%
19457.4	1	0.1%
19699.8	1	0.1%
20032.3	1	0.1%
20336.6	1	0.1%

Value	Count	Frequency (%)
370914.9	1	0.1%
327746.7	1	0.1%
320531.8	1	0.1%
315803.7	1	0.1%
315329.8	1	0.1%
314177.3	1	0.1%
311919.5	1	0.1%
311091.5	1	0.1%
300785.6	1	0.1%
299673	1	0.1%

Nuclear Generation
Real number (ℝ_≥0)

Distinct	1201
Distinct (%)	99.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	152036.1632

Minimum	90283.3
Maximum	170911.7
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.6 KiB

Quantile statistics

Minimum	90283.3
5-th percentile	105512.96
Q1	142710
median	165590.4
Q3	169476.8
95-th percentile	170591.34
Maximum	170911.7
Range	80628.4
Interquartile range (IQR)	26766.8

Descriptive statistics

Standard deviation	21372.69546
Coefficient of variation (CV)	0.1405763932
Kurtosis	0.1964844081
Mean	152036.1632
Median Absolute Deviation (MAD)	5020.9
Skewness	-1.09948153
Sum	183811721.3
Variance	456792111.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
166621.8	3	0.2%
170453.2	2	0.2%
170754.2	2	0.2%
166366.8	2	0.2%
119748	2	0.2%
166607.6	2	0.2%
170360.4	2	0.2%
146416.4	1	0.1%
146425.2	1	0.1%
146449.2	1	0.1%
Other values (1191)	1191	98.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
90283.3	1	0.1%
90347.3	1	0.1%
90362.4	1	0.1%
90539.7	1	0.1%
91573.1	1	0.1%
91663.2	1	0.1%
91863.6	1	0.1%
92010.3	1	0.1%
92031	1	0.1%
92277.6	1	0.1%

Value	Count	Frequency (%)
170911.7	1	0.1%
170882.9	1	0.1%
170859.1	1	0.1%
170854.1	1	0.1%
170843.4	1	0.1%
170841.7	1	0.1%
170840.2	1	0.1%
170835.2	1	0.1%
170834.2	1	0.1%
170815.8	1	0.1%

Total emissions (tCO2eq)
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	1209
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	103360.9096

Minimum	42214.689
Maximum	269859.051
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.6 KiB

Quantile statistics

Minimum	42214.689
5-th percentile	55193.9962
Q1	74132.571
median	96719.783
Q3	124557.649
95-th percentile	175192.739
Maximum	269859.051
Range	227644.362
Interquartile range (IQR)	50425.078

Descriptive statistics

Standard deviation	37866.22371
Coefficient of variation (CV)	0.3663495594
Kurtosis	1.054798152
Mean	103360.9096
Median Absolute Deviation (MAD)	24532.851
Skewness	0.9691845456
Sum	124963339.8
Variance	1433850898
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
221495.491	1	0.1%
64932.318	1	0.1%
55283.343	1	0.1%
62236.112	1	0.1%
76755.473	1	0.1%
83707.012	1	0.1%
83694.347	1	0.1%
85357.85	1	0.1%
67637.623	1	0.1%
49585.722	1	0.1%
Other values (1199)	1199	99.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
42214.689	1	0.1%
42995.124	1	0.1%
45334.368	1	0.1%
46521.637	1	0.1%
46674.957	1	0.1%
46998.608	1	0.1%
47427.666	1	0.1%
47739.26	1	0.1%
47975.859	1	0.1%
48156.065	1	0.1%

Value	Count	Frequency (%)
269859.051	1	0.1%
268388.116	1	0.1%
265329.503	1	0.1%
258317.361	1	0.1%
242400.303	1	0.1%
237737.057	1	0.1%
229900.038	1	0.1%
229509.441	1	0.1%
226454.682	1	0.1%
226088.16	1	0.1%

tCO2/MWh
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	208
Distinct (%)	17.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1583316791

Minimum	0.066
Maximum	0.332
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.6 KiB

Quantile statistics

Minimum	0.066
5-th percentile	0.088
Q1	0.124
median	0.155
Q3	0.188
95-th percentile	0.237
Maximum	0.332
Range	0.266
Interquartile range (IQR)	0.064

Descriptive statistics

Standard deviation	0.04593039289
Coefficient of variation (CV)	0.2900897228
Kurtosis	0.06589147726
Mean	0.1583316791
Median Absolute Deviation (MAD)	0.032
Skewness	0.4332925895
Sum	191.423
Variance	0.002109600991
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.184	17	1.4%
0.159	17	1.4%
0.179	16	1.3%
0.146	16	1.3%
0.138	16	1.3%
0.127	15	1.2%
0.156	14	1.2%
0.154	13	1.1%
0.121	13	1.1%
0.124	13	1.1%
Other values (198)	1059	87.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.066	2	0.2%
0.067	1	0.1%
0.069	4	0.3%
0.07	1	0.1%
0.071	2	0.2%
0.072	1	0.1%
0.073	3	0.2%
0.074	2	0.2%
0.075	1	0.1%
0.076	1	0.1%

Value	Count	Frequency (%)
0.332	1	0.1%
0.33	1	0.1%
0.329	1	0.1%
0.325	1	0.1%
0.308	1	0.1%
0.307	1	0.1%
0.294	1	0.1%
0.291	1	0.1%
0.289	1	0.1%
0.281	1	0.1%

Electricity Price
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1065
Distinct (%)	88.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	80.59485525

Minimum	0.51
Maximum	510.26
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.6 KiB

Quantile statistics

Minimum	0.51
5-th percentile	20.7
Q1	36.82
median	49.76
Q3	90.24
95-th percentile	240.232
Maximum	510.26
Range	509.75
Interquartile range (IQR)	53.42

Descriptive statistics

Standard deviation	74.28813572
Coefficient of variation (CV)	0.9217478645
Kurtosis	3.354340898
Mean	80.59485525
Median Absolute Deviation (MAD)	16.66
Skewness	1.867278574
Sum	97439.18
Variance	5518.727108
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.95	6	0.5%
40	6	0.5%
37	5	0.4%
45	4	0.3%
30	4	0.3%
39.07	4	0.3%
51	4	0.3%
60	3	0.2%
42.07	3	0.2%
93.35	3	0.2%
Other values (1055)	1167	96.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.51	1	0.1%
1.94	1	0.1%
1.95	6	0.5%
2.38	1	0.1%
3.5	1	0.1%
4.64	1	0.1%
4.72	1	0.1%
5.02	1	0.1%
5.5	1	0.1%
5.95	1	0.1%

Value	Count	Frequency (%)
510.26	1	0.1%
450.95	1	0.1%
441.85	1	0.1%
390.61	1	0.1%
386.1	1	0.1%
378	1	0.1%
376.5	1	0.1%
354.49	1	0.1%
350	1	0.1%
343.08	1	0.1%

Electricity Price 24h
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1065
Distinct (%)	88.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	80.44333333

Minimum	0.51
Maximum	510.26
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.6 KiB

Quantile statistics

Minimum	0.51
5-th percentile	20.7
Q1	36.82
median	49.86
Q3	89.8
95-th percentile	240.232
Maximum	510.26
Range	509.75
Interquartile range (IQR)	52.98

Descriptive statistics

Standard deviation	74.21130924
Coefficient of variation (CV)	0.9225290172
Kurtosis	3.396172698
Mean	80.44333333
Median Absolute Deviation (MAD)	16.74
Skewness	1.876916279
Sum	97255.99
Variance	5507.318419
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40	6	0.5%
1.95	6	0.5%
37	5	0.4%
30	4	0.3%
39.07	4	0.3%
45	4	0.3%
51	4	0.3%
55	3	0.2%
150	3	0.2%
42.07	3	0.2%
Other values (1055)	1167	96.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.51	1	0.1%
1.94	1	0.1%
1.95	6	0.5%
2.38	1	0.1%
3.5	1	0.1%
4.64	1	0.1%
4.72	1	0.1%
5.02	1	0.1%
5.5	1	0.1%
5.51	1	0.1%

Value	Count	Frequency (%)
510.26	1	0.1%
450.95	1	0.1%
441.85	1	0.1%
390.61	1	0.1%
386.1	1	0.1%
378	1	0.1%
376.5	1	0.1%
354.49	1	0.1%
350	1	0.1%
343.08	1	0.1%

Electricity Price 7d
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1065
Distinct (%)	88.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	79.58015715

Minimum	0.51
Maximum	510.26
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.6 KiB

Quantile statistics

Minimum	0.51
5-th percentile	20.7
Q1	36.53
median	49.89
Q3	88.61
95-th percentile	238.044
Maximum	510.26
Range	509.75
Interquartile range (IQR)	52.08

Descriptive statistics

Standard deviation	73.38094199
Coefficient of variation (CV)	0.9221009937
Kurtosis	3.665363304
Mean	79.58015715
Median Absolute Deviation (MAD)	16.71
Skewness	1.925258256
Sum	96212.41
Variance	5384.762648
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40	6	0.5%
1.95	6	0.5%
37	5	0.4%
30	4	0.3%
45	4	0.3%
39.07	4	0.3%
35	4	0.3%
45.1	3	0.2%
50.29	3	0.2%
55	3	0.2%
Other values (1055)	1167	96.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.51	1	0.1%
1.94	1	0.1%
1.95	6	0.5%
2.38	1	0.1%
3.5	1	0.1%
4.64	1	0.1%
4.72	1	0.1%
5.02	1	0.1%
5.5	1	0.1%
5.51	1	0.1%

Value	Count	Frequency (%)
510.26	1	0.1%
450.95	1	0.1%
441.85	1	0.1%
390.61	1	0.1%
386.1	1	0.1%
378	1	0.1%
376.5	1	0.1%
354.49	1	0.1%
350	1	0.1%
343.08	1	0.1%

Gas Price
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	310
Distinct (%)	86.6%
Missing	851
Missing (%)	70.4%
Infinite	0
Infinite (%)	0.0%
Mean	15.25851955

Minimum	7.8
Maximum	27.94
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.6 KiB

Quantile statistics

Minimum	7.8
5-th percentile	10.2175
Q1	12.8025
median	14.165
Q3	17.09
95-th percentile	24.3905
Maximum	27.94
Range	20.14
Interquartile range (IQR)	4.2875

Descriptive statistics

Standard deviation	3.993439128
Coefficient of variation (CV)	0.2617186493
Kurtosis	0.8339706174
Mean	15.25851955
Median Absolute Deviation (MAD)	1.79
Skewness	1.079255339
Sum	5462.55
Variance	15.94755607
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14.55	3	0.2%
13.52	3	0.2%
13.99	2	0.2%
9.13	2	0.2%
10.75	2	0.2%
11.8	2	0.2%
14.59	2	0.2%
13.19	2	0.2%
17	2	0.2%
15.07	2	0.2%
Other values (300)	336	27.8%
(Missing)	851	70.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
7.8	1	0.1%
8.38	1	0.1%
8.44	1	0.1%
8.84	1	0.1%
8.93	1	0.1%
8.95	1	0.1%
9.04	1	0.1%
9.09	1	0.1%
9.13	2	0.2%
9.23	1	0.1%

Value	Count	Frequency (%)
27.94	1	0.1%
27.12	1	0.1%
27.04	1	0.1%
26.65	1	0.1%
26.38	1	0.1%
26.26	1	0.1%
25.83	1	0.1%
25.77	1	0.1%
25.73	1	0.1%
25.64	1	0.1%

Gas Price 24h
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1014
Distinct (%)	83.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	31.38356493

Minimum	4.17
Maximum	224.38
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.6 KiB

Quantile statistics

Minimum	4.17
5-th percentile	6.198
Q1	11.71
median	16.24
Q3	34.87
95-th percentile	97.8
Maximum	224.38
Range	220.21
Interquartile range (IQR)	23.16

Descriptive statistics

Standard deviation	33.1182748
Coefficient of variation (CV)	1.055274469
Kurtosis	3.741255987
Mean	31.38356493
Median Absolute Deviation (MAD)	6.75
Skewness	1.916117177
Sum	37942.73
Variance	1096.820126
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16.02	3	0.2%
14.88	3	0.2%
13.18	3	0.2%
16.1	3	0.2%
13.34	3	0.2%
13.52	3	0.2%
10.82	3	0.2%
18.56	3	0.2%
14.76	3	0.2%
17.73	3	0.2%
Other values (1004)	1179	97.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4.17	1	0.1%
4.23	1	0.1%
4.6	2	0.2%
4.9	1	0.1%
4.94	1	0.1%
5.02	1	0.1%
5.07	1	0.1%
5.08	1	0.1%
5.12	1	0.1%
5.17	2	0.2%

Value	Count	Frequency (%)
224.38	1	0.1%
213.6	1	0.1%
193.11	1	0.1%
182.96	1	0.1%
181.54	1	0.1%
172.12	1	0.1%
169.39	1	0.1%
162.17	1	0.1%
161.98	1	0.1%
154.76	1	0.1%

Gas Price 7d
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1013
Distinct (%)	83.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	31.09038875

Minimum	4.17
Maximum	224.38
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.6 KiB

Quantile statistics

Minimum	4.17
5-th percentile	6.198
Q1	11.71
median	16.24
Q3	34.13
95-th percentile	97.8
Maximum	224.38
Range	220.21
Interquartile range (IQR)	22.42

Descriptive statistics

Standard deviation	32.91052519
Coefficient of variation (CV)	1.05854338
Kurtosis	3.949516276
Mean	31.09038875
Median Absolute Deviation (MAD)	6.75
Skewness	1.958777839
Sum	37588.28
Variance	1083.102668
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16.53	3	0.2%
14.76	3	0.2%
8.14	3	0.2%
18.56	3	0.2%
13.34	3	0.2%
16.24	3	0.2%
14.33	3	0.2%
13.3	3	0.2%
16.02	3	0.2%
11.61	3	0.2%
Other values (1003)	1179	97.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4.17	1	0.1%
4.23	1	0.1%
4.6	2	0.2%
4.9	1	0.1%
4.94	1	0.1%
5.02	1	0.1%
5.07	1	0.1%
5.08	1	0.1%
5.12	1	0.1%
5.17	2	0.2%

Value	Count	Frequency (%)
224.38	1	0.1%
213.6	1	0.1%
193.11	1	0.1%
182.96	1	0.1%
181.54	1	0.1%
172.12	1	0.1%
169.39	1	0.1%
162.17	1	0.1%
161.98	1	0.1%
154.76	1	0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	datetime	Consumption	Solar Generation	Wind Generation	Hydropower Generation	Pump Hydro Generation	Combined Cycle Generation	Nuclear Generation	Total emissions (tCO2eq)	tCO2/MWh	Electricity Price	Electricity Price 24h	Electricity Price 7d	Gas Price	Gas Price 24h	Gas Price 7d
0	2019-01-08	805391.7	16757.9	171527.7	55914.4	8632.8	120908.1	170577.3	221495.491	0.272	59.59	59.59	66.88	25.46	25.26	24.45
1	2019-01-09	804813.2	16267.5	240796.6	41528.8	2160.8	83088.1	170472.3	211748.418	0.250	54.09	59.59	61.74	26.26	25.46	24.87
2	2019-01-10	812677.0	17381.3	254571.2	49847.8	6312.5	100567.0	170458.8	198839.785	0.229	58.60	54.09	62.01	25.01	26.26	24.67
3	2019-01-11	824726.7	17521.0	208192.7	56627.6	5181.5	132320.7	170326.7	202390.528	0.236	60.84	58.60	67.20	25.83	25.01	26.07
4	2019-01-12	732330.3	16823.8	178126.0	32378.8	171.0	85428.6	170420.6	170297.863	0.230	67.18	60.84	71.68	24.84	25.83	25.21
5	2019-01-13	685968.7	16659.0	179078.2	36493.3	3610.4	72341.1	170055.1	164868.113	0.230	57.48	67.18	63.75	24.65	24.84	24.86
6	2019-01-14	797089.6	16963.2	176051.2	46252.1	1417.7	140301.3	170352.4	229900.038	0.275	60.00	57.48	59.59	25.73	24.65	25.26
7	2019-01-15	804682.5	15296.6	56366.1	71796.7	4996.3	194768.8	170324.9	265329.503	0.330	60.00	60.00	59.59	27.12	25.73	25.46
8	2019-01-16	807008.8	13647.2	55128.0	76225.3	3168.8	192815.7	170387.7	269859.051	0.332	70.16	60.00	54.09	27.94	27.12	26.26
9	2019-01-17	811027.4	9787.5	94843.7	62607.0	4504.7	161302.4	170529.2	258317.361	0.329	67.36	70.16	58.60	26.38	27.94	25.01

Last rows

	datetime	Consumption	Solar Generation	Wind Generation	Hydropower Generation	Pump Hydro Generation	Combined Cycle Generation	Nuclear Generation	Total emissions (tCO2eq)	tCO2/MWh	Electricity Price	Electricity Price 24h	Electricity Price 7d	Gas Price	Gas Price 24h	Gas Price 7d
1199	2022-04-21	654314.3	95522.0	238029.7	51202.4	6587.8	54681.5	165912.3	76981.914	0.102	154.50	125.01	232.45	NaN	74.10	88.14
1200	2022-04-22	656665.6	38110.6	192322.4	52241.9	7950.5	81128.7	160081.7	91964.568	0.137	216.06	154.50	214.90	NaN	82.85	80.52
1201	2022-04-23	585714.3	74847.9	358213.8	32675.7	9753.9	32779.7	145673.3	62311.284	0.082	180.21	216.06	222.43	NaN	83.76	77.31
1202	2022-04-24	531093.4	100440.9	189947.7	37424.7	8863.5	81333.8	134852.1	79587.481	0.117	144.00	180.21	160.22	NaN	77.85	73.85
1203	2022-04-25	618297.0	108105.9	38786.7	49228.5	2676.0	159859.6	119952.6	124532.691	0.189	267.43	144.00	95.90	NaN	81.26	67.07
1204	2022-04-26	641312.9	81619.0	63729.6	53010.1	1625.4	202367.1	120648.2	144634.362	0.207	237.76	267.43	120.00	NaN	85.51	68.69
1205	2022-04-27	652403.0	68119.2	44722.5	60676.0	NaN	209518.8	120739.8	149748.150	0.219	211.96	237.76	125.01	NaN	84.77	74.10
1206	2022-04-28	649448.2	70969.9	88910.2	73743.9	NaN	133254.5	120696.0	127193.273	0.190	219.39	211.96	154.50	NaN	83.14	82.85
1207	2022-04-29	635568.0	105498.0	86633.0	80855.8	NaN	127220.2	123233.9	124025.667	0.173	206.05	219.39	216.06	NaN	88.58	83.76
1208	2022-04-30	554742.8	100820.6	115253.3	66424.9	NaN	83544.2	136806.4	84387.180	0.124	204.78	206.05	180.21	NaN	81.32	77.85

Overview

Variables

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows